Whether you are an Excel neophyte, a sophisticate who knows the program inside out, or an intermediate-level plodder eager to hone your skills, "Excel: The Missing Manual" is sure to become your go-to resource for all things Excel. Covering all the features of Excel 2002 and 2003, the most recent versions for Windows, "Excel: The Missing Manual" is an easy-to-read, thorough and downright enjoyable guide to one of the world's most popular, (and annoyingly complicated ) computer programs.Never a candidate for "the most user-friendly of Microsoft programs," Excel demands study, practice and dedication to gain even a working knowledge of the basics. Excel 2003 is probably even tougher to use than any previous version of Excel. However, despite its fairly steep learning curve, this marvelously rich program enables users of every stripe to turn data into information using tools to analyze, communicate, and share knowledge. Excel can help you to collaborate effectively, and protect and control access to your work. Power users can take advantage of industry-standard Extensible Markup Language (XML) data to connect to business processes.To unleash the power of the program and mine the full potential of their database talents, users need an authorative and friendly resource. None is more authoritative or friendlier than "Excel: The Missing Manual." Not only does the book provide exhaustive coverage of the basics, it provides numerous tips and tricks, as well as advanced data analysis, programming and Web interface knowledge that pros can adopt for their latest project. Neophytes will find everything they need to create professional spreadsheets and become confident users."Excel: The Missing Manual" covers: worksheet basics, formulas and functions, organizing worksheets, charts and graphics, advanced data analysis, sharing data with the rest of the world, and programming.If you buy just one book about using Excel, this has GOT to be it. This book has all you need to help you excel at Excel.

Whether you're a budding blogger or seasoned web designer, WordPress is a brilliant tool for creating websites - once you know how to tap into its impressive features. The latest edition of this jargon-free Missing Manual shows you how to use WordPress's themes, widgets, and plug-ins to build just about any kind of site. The important stuff you need to know: Set up WordPress. Configure WordPress on your web host or get it running on your home computer. Create your site. Get hands-on instructions for building all types of websites, from blogs to business sites with ecommerce features. Jazz it up. Add picture galleries, slideshows, video clips, music players, and podcasts. Add features. Select from thousands of plug-ins to enhance your site's capabilities, from contact forms to a basic shopping cart. Build a truly unique site. Customize a WordPress theme to create a site that looks exactly the way you want. Attract an audience. Use SEO, site statistics, and social sharing to reach more people. Stay safe. Use backup and staging tools to protect your content and avoid catastrophe.

Social Psychology and Theories of Consumer Culture: A Political Economy Perspective presents a critical analysis of the leading positions in social psychology from the perspective of classical and contemporary theories of consumer culture. The analysis seeks to expand social psychological theory by focusing on the interface between modern western culture (consumer culture) and social behaviour. McDonald and Wearing argue that if social psychology is to play a meaningful role in solving some of society's most pressing problems (e.g. global warming, obesity, addiction, alienation, and exclusion) then it needs to incorporate a more comprehensive understanding and analysis of consumer culture. Wide-ranging and challenging, the book offers a fresh insight into critical social psychology appropriate for upper undergraduate and postgraduate courses in personality, social psychology, critical and applied psychology. It will also appeal to those working in clinical, counselling, abnormal, and environmental psychology and anyone with an interest in the integration of social psychology and theories of consumer culture.

The dominant spreadsheet program and one of the most widely used software applications in the world, Microsoft Excel is unbelievably powerful - and can be downright intimidating. If you're new to Excel or among the many existing Excel users who are dazed and confused by all that the program can do (and by how little it has actually done for you), "Excel for Starter: The Missing Manual" is your ideal resource. For everyone who wants to quickly get up to speed on Excel to create, organize, and present household and/or office data and information, this smart new guide delivers just the essentials: it concentrates on the must-have information and the best, most practical Excel features that people like you can use to maximize your productivity and minimize your spreadsheet confusion and frustration. "Excel for Starters: The Missing Manual" demystifies spreadsheets, and explains how to use them most effectively and efficiently. Clear explanations (with lots of examples), step-by-step instructions, helpful illustrations, and timesaving advice guide you through all the most common and useful features of Excel 2002 and 2003 - including how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions. Sure, there are plenty more thorough, more massive Excel books on the bookstore shelves. But why wade your way through a swamp of details you'll never need - or want - to use? Let author Matthew MacDonald, an educator and software developer who also wrote the highly popular "Excel: The Missing Manual", be your trusted guide as you learn which Excel features will serve you best and which are best ignored. Utterly practical and refreshingly funny, this down-to-earth guide gives you nothing more (and nothing less) than what you need to make Excel do exactly what you want it to do. It's a quick read you'll want to keep on hand for reference again and again.

Social Psychology and Theories of Consumer Culture: A Political Economy Perspective presents a critical analysis of the leading positions in social psychology from the perspective of classical and contemporary theories of consumer culture. The analysis seeks to expand social psychological theory by focusing on the interface between modern western culture (consumer culture) and social behaviour. McDonald and Wearing argue that if social psychology is to play a meaningful role in solving some of society's most pressing problems (e.g. global warming, obesity, addiction, alienation, and exclusion) then it needs to incorporate a more comprehensive understanding and analysis of consumer culture. Wide-ranging and challenging, the book offers a fresh insight into critical social psychology appropriate for upper undergraduate and postgraduate courses in personality, social psychology, critical and applied psychology. It will also appeal to those working in clinical, counselling, abnormal, and environmental psychology and anyone with an interest in the integration of social psychology and theories of consumer culture.

Why reinvent the wheel every time you run into a problem with JavaScript? This cookbook is chock-full of code recipes for common programming tasks, along with techniques for building apps that work in any browser. You'll get adaptable code samples that you can add to almost any project--and you'll learn more about JavaScript in the process. The recipes in this book take advantage of the latest features in ECMAScript 2020 and beyond and use modern JavaScript coding standards. You'll learn how to: Set up a productive development environment with a code editor, linter, and test server Work with JavaScript data types, such as strings, arrays, and BigInts Improve your understanding of JavaScript functions, including arrow functions, closures, and generators Apply object-oriented programming concepts like classes and inheritance Work with rich media in JavaScript, including audio, video, and SVGs Manipulate HTML markup and CSS styles Use JavaScript anywhere with Node.js Access and manipulate remote data with REST, GraphQL, and Fetch Get started with the popular Express application-building framework Perform asynchronous operations with Promises, async/await, and web workers

Mastering the development of .NET 4.0 applications in C# is less about knowing the Visual C# 2010 language and more about knowing how to use the functionality of the .NET framework class library most effectively. Visual C# 2010 Recipes explores the breadth of the .NET Framework class library and provides specific solutions to common and interesting programming problems. Each recipe is presented in a succinct problem/solution format and is accompanied by a working code sample to help you understand the concept and quickly apply it.

When you are facing a Visual C# 2010 problem, this book likely contains a recipeprovidingthe solutionor at least points you in the right direction. Even if you are simply looking to broaden your knowledge of the .NET framework class library, Visual C# 2010 Recipes is the perfect resource to assist you.

This is an updated reference for .NET 4.0 programmers. All code samples come as stand-alone Visual Studio 2010 solutions for your convenience. What you'll learn Clear, concise answers to myriad problems that occur during day-to-day C# 2010 development How to write code according to Microsoft's best practice guidelines Answers to questions covering everything from workflow to XML processing Who this book is for

While there are few developers who do not stand to learn something from this book's concise, solution-oriented format, it is primarily aimed at emerging software professionals taking their first steps into the IT marketplace. These newly qualified and relatively inexperienced developers will gain the most from the book's comprehensive content and fast-access design, which is aimed at helping them cope with the problems and pitfalls that regularly occur when learning a new technology. Table of Contents Application Development Data Manipulation Application Domains, Reflection, and Metadata Threads, Processes, and Synchronization Files, Directories, and I/O XML Processing Windows Forms Graphics, Multimedia, and Printing Database Access Networking Security and Cryptography Unmanaged Code Interoperability Commonly Used Interfaces and Patterns Windows Integration Parallel Programming Using LINQ Windows Presentation Foundation

What, exactly, do you know about your body? Do you know how your immune system works? Or what your pancreas does? Or the myriad -- and often simple -- ways you can improve the way your body functions?This full-color, visually rich guide answers these questions and more. Matthew MacDonald, noted author of Your Brain: The Missing Manual, takes you on a fascinating tour of your body from the outside in, beginning with your skin and progressing to your vital organs. You'll look at the quirks, curiosities, and shortcomings we've all learned to live with, and pick up just enough biology to understand how your body works. You'll learn: That you shed skin more frequently than snakes doWhy the number of fat cells you have rarely changes, no matter how much you diet or exercise -- they simply get bigger or smallerHow you can measure and control fatThat your hair is made from the same stuff as horses' hoovesThat you use only a small amount of the oxygen you inhaleWhy blood pressure is a more important health measure than heart rate -- with four ways to lower dangerously high blood pressureWhy our bodies crave foods that make us fatHow to use heart rate to shape an optimal workout session -- one that's neither too easy nor too strenuousWhy a tongue with just half a dozen taste buds can identify thousands of flavorsWhy bacteria in your gut outnumbers cells in your body -- and what function they serveWhy we age, and why we can't turn back the clockWhat happens to your body in the minutes after you die

Rather than dumbed-down self-help or dense medical text, Your Body: The Missing Manual is entertaining and packed with information you can use. It's a book that may well change your life.Reader comments for Your Brain: The Missing Manual, also by author Matthew MacDonald: "Popular books on the brain are often minefields of attractive but inaccurate information. This one manages to avoid most of the hype and easy faulty generalizations while providing easy to read and digest information about the brain. It has useful tricks without the breathless hype of many popular books."-- Elizabeth Zwicky, The Usenix Magazine

..".a unique guide that should be sought after by any who want to maximize what they can accomplish with their mental abilities and resources."-- James A. Cox, The Midwest Book Review - Wisconsin Bookwatch

"If you can't figure out how to use your brain after reading this guide, you may want to return your brain for another."-- The Sacramento Book Review, Volume 1, Issue 2, Page 19

"It's rare to find a book on any technical subject that is as well written and readable as Your Brain: The Missing Manual. The book covers pretty much anything you may want to know about your brain, from what makes it up, through how it develops to how to mitigate the affects of aging. The book is easy reading, fact packed and highlighted notes and practical applications. So if you want to learn more about your brain, how it works, how to get the best out of it or just want to stave off the ravages of Alzheimers (see chapter ten for details of how learning helps maintain your brain) then I can't recommend this book highly enough."-- Neil Davis, Amazon.co.uk

"MacDonald's writing style is perfect for this kind of guide. It remains educational without becoming overly technical or using unexplained jargon. And even though the book covers a broad scope of topics, MacDonald keeps it well organized and easy to follow. The book captures your attention with fun facts and interesting studies that any person could apply to their own understanding of human ability. It has great descriptions of the brain and its interconnected parts, as well as providing full color pictures and diagrams to offer a better explanation of what the author is talking about."-- Janica Unruh, Blogcritics Magazine

Fast-paced and easy to use, this guide shows you how to get the most out of Excel 2010 - everything from building your first spreadsheet to working with Pivot tables. You'll learn how to develop a spreadsheet from scratch, create formulas, add data, and analyze and graph data so you can make informed business decisions. With clear jargon-free explanations, step-by-step instructions, tons of illustrations, and lots of undocumented workarounds, tips, and shortcuts, you'll get hands-on guided tours and explanations of Excel's new features, including: the Excel Web App - for the first time, Excel lets you view, edit, and share your worksheets in a web browser; sparklines - these miniature graphs are the hottest innovation in data display since the pie chart - they're ideal for viewing trends and summaries at a glance; backstage view - now Excel has a single go-to place for managing files, such as opening an existing spreadsheet, creating a new one, printing, or setting options; and, slicers - Excel's pivot tables are powerful but complicated - slicers give you a visual way to slice and dice pivot table data so you can see details that interest you most.

You can easily create a professional-looking website with nothing more than an ordinary computer and some raw ambition. Want to build a blog, sell products, create forums, or promote an event? No problem! This friendly, jargon-free book gives you the techniques, tools, and advice you need to build a site and get it up on the Web. The important stuff you need to know: Master the basics. Learn HTML5, the language of the Web. Design good-looking pages. Use styles to build polished layouts. Get it online. Find a reliable web host and pick a good web address. Use time-saving tools. Learn free tools for creating web pages and tracking your visitors. Attract visitors. Make sure people can find your site through popular search engines like Google. Build a community. Encourage repeat visits with social media. Bring in the cash. Host Google ads, sell Amazon's wares, or push your own products that people can buy via PayPal. Add pizzazz. Include audio, video, interactive menus, and a pinch of JavaScript.

When Microsoft introduced the Visual Basic .NET programming language, as part of its move to the .NET Framework two years ago, many developers willingly made the switch. Millions of others, however, continued to stick with Visual Basic 6. They weren't ready for such a radical change, which included an object-oriented environment similar to Java. They liked the old Visual Basic just fine.

In an effort to win over those diehard VB6 developers, the company has included a new version of VB.NET in its upcoming next generation release of the Visual Studio .NET development platform. Visual Basic 2005 comes with innovative language constructs, new compiler features, dramatically enhanced productivity and an improved debugging experience. The language's new version is now available in beta release, and Microsoft is encouraging developers to give it a test drive.

"Visual Basic 2005: A Developer's Notebook" provides the ideal test track. With nearly 50 hands-on projects, this practical introduction to VB 2005 will bring you up to speed on all the new features of this language by allowing you to work with them directly. The book summarizes the changes that VB 2005 brings, and tells you how to acquire, install and configure the beta version of VB 2005 SDK. Each project or experiment explores a different feature, with emphasis on changes that can increase productivity, simplify programming tasks, and help you add new functionality to your applications.

This one-of-a-kind book also offers suggestions for further experimentation, links to on-line documentation and other sources of information, and practical notes and warnings from the author.

The new Developer's Notebooks series from O'Reilly offers an in-depth first look at important new tools for software developers. Emphasizing example over explanation and practice over theory, they focus on learning by doing you'll get the goods straight from the masters, in an informal and code-intensive style. For those who want to get up speed with VB 2005 right away, this is the perfect all lab, no lecture guide.

The Microsoft Windows Presentation Foundation provides the foundation for building applications and high-quality user experiences in Windows Vista. WPF blends application user interface, documents, and media content to provide richer control, design, and development of the visual aspects of Windows programs. Author Matthew MacDonald shows you how WPF really works. His no-nonsense, practical advice will get you building high-quality WPF applications quickly and easily. MacDonald will take you through a thorough investigation of the more advanced aspects of WPF, and its relation to other elements of the WinFX stack and the .NET Framework 3.5, to complete your understanding of WPF and C# 2008. WPFs functionality extends to support for Tablet PCs and other forms of input device, and provides a more modern imaging and printing pipeline, accessibility and UI automation infrastructure, data-driven UI and visualization, as well as the integration points for weaving the application experience into the Windows shell. What you'll learn WPF basics: XAML, layout, control essentials, and data flow WPF applications: Navigation, commands, localization, and deployment Advanced controls: Custom controls, menus, toolbars, and trees WPF documents: Text layout, printing, and document packaging Graphics and multimedia: Drawing shapes, sound and video, animation, geometric transformations, and imaging Who is this book for? Developers encountering WPF and .NET 3.5 for the first time in their professional lives About the Apress Pro Series The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder. You have gotten the job, now youneed to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard-won solutions to problems you will face in your professional programming career. Related Titles Foundations of WPF: An Introduction to Windows Presentation Foundation Pro Silverlight

Access is the most complex and intimidating application in Microsoft Office, but you'll tame it quickly with this book. You'll learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry in no time. With "Microsoft Access 2010: The Missing Manual", you'll even delve into the black art of Access programming by learning valuable tricks and techniques to automate common tasks - even if you've never touched a line of code before. Discover new pre-built databases you can customize to fit your needs, and learn how Access' new complex data feature will simplify your life. With plenty of downloadable examples, this objective and engaging book will turn any Access neophyte into a true master. Follow step-by-step instructions for creating and perfecting an Access database, and learn methods for using and maintaining it. Understand Access' interface, and focus on new time-saving features. Learn basic Access programming quickly and easily. Get good database design practices and tips from the pros.

This book will follow the proven pattern of its previous .NET 2.0 and .NET 1.1 editions, teaching novice users how to use ASP.NET by gradually building their knowledge of the technology up in a pyramidal fashion chapter by chapter. Comprehensively revised for both ASP.NET 3.5 and the new VB 9.0 language this book presents the easiest path to ASP.NET 3.5 mastery. This is one of the first books introducing novices to this important new technology area, and is written specifically in their coding language of preference. The book is written by a proven and award winning .NET author that has been following the technology release cycle since its inception.

HTML5 is more than a markup language - it's a collection of several independent web standards. Fortunately, this expanded guide covers everything you need in one convenient place. With step-by-step tutorials and real-world examples, HTML5: The Missing Manual shows you how to build web apps that include video tools, dynamic graphics, geolocation, offline features, and responsive layouts for mobile devices. The important stuff you need to know: Structure web pages more effectively. Learn how HTML5 helps web design tools and search engines work smarter. Add audio and video without plugins. Build playback pages that work in every browser. Create stunning visuals with Canvas. Draw shapes, pictures, and text; play animations; and run interactive games. Jazz up your pages with CSS3. Add fancy fonts and eye-catching effects with transitions and animation. Design better web forms. Collect information from visitors more efficiently with HTML5 form elements. Build it once, run it everywhere. Use responsive design to make your site look good on desktops, tablets, and smartphones. Include rich desktop features. Build self-sufficient web apps that work offline and store the data users need.

Puzzles and brain twisters to keep your mind sharp and your memory intact are all the rage today. More and more people - baby Boomers and information workers in particular - are becoming concerned about their gray matter's ability to function, and with good reason. As this sensible and entertaining guide points out, your brain is easily your most important possession. It deserves proper upkeep. "Your Brain: The Missing Manual" is a practical look at how to get the most out of your brain - not just how the brain works, but how you can use it more effectively. What makes this book different than the average self-help guide is that it's grounded in current neuroscience.You get a quick tour of several aspects of the brain, complete with useful advice about: Brain Food - the right fuel for the brain and how the brain commands hunger (including an explanation of the different chemicals that control appetite and cravings); Sleep - the sleep cycle and circadian rhythm, and how to get a good night's sleep (or do the best you can without it); Memory - techniques for improving your recall; Reason - learning to defeat common sense; logical fallacies (including tactics for winning arguments); and good reasons for bad prejudices. Creativity and Problem-Solving - brainstorming tips and thinking not outside the box, but about the box - in other words, find the assumptions that limit your ideas so you can break through them; Understanding Other People's Brains - the battle of the sexes and babies developing brainsLearn about the built-in circuitry that makes office politics seem like a life-or-death struggle, causes you to toss important facts out of your memory if they're not emotionally charged, and encourages you to eat huge amounts of high-calorie snacks.With "Your Brain: The Missing Manual", you'll discover that, sometimes, you can learn to compensate for your brain or work around its limitations - or at least to accept its eccentricities. Exploring your brain is the greatest adventure and biggest mystery you'll ever face. This guide has exactly the advice you need.

Microsoft's Windows Presentation Foundation (WPF) provides you with a development framework for building high-quality user experiences for the Windows operating system. It blends together rich content from a wide range of sources and allows you unparalleled access to the processing power of your Windows computer. Pro WPF 4.5 in C# provides a thorough, authoritative guide to how WPF really works. Packed with no-nonsense examples and practical advice you'll learn everything you need to know in order to use WPF in a professional setting. The book begins by building a firm foundation of elementary concepts, using your existing C# skills as a frame of reference, before moving on to discuss advanced concepts and demonstrate them in a hands-on way that emphasizes the time and effort savings that can be gained.